package com.faf.dao;

import java.sql.SQLException;
import java.util.ArrayList;

import com.faf.bean.Comment;
import com.faf.bean.Food;
import com.faf.bean.Store;

public interface AccessDao extends BaseDao {
	public void newAccess(int storeId, int foodId, int userId) throws SQLException;

	public long getAccessByStoreId(int storeId) throws SQLException;

	public long getAccessByStoreId_TimeStamp_After(int storeId, long tms) throws SQLException;

	public long getAccessByStoreId_TimeStamp_Before(int storeId, long tms) throws SQLException;

	public long getAccessByStoreId_TimeStamp_Between(int storeId, long from, long to) throws SQLException;

	public long getAccessByStoreNumber(String storeNumber) throws SQLException;

	public long getAccessByStoreNumber_TimeStamp_After(String storeNumber, long tms) throws SQLException;

	public long getAccessByStoreNumber_TimeStamp_Before(String storeNumber, long tms) throws SQLException;

	public long getAccessByStoreNumber_TimeStamp_Between(String storeNumber, long from, long to) throws SQLException;

	public long getAccessByFoodId(int foodId) throws SQLException;

	public long getAccessByFoodId_TimeStamp_After(int foodId, long tms) throws SQLException;

	public long getAccessByFoodId_TimeStamp_Before(int foodId, long tms) throws SQLException;

	public long getAccessByFoodId_TimeStamp_Between(int foodId, long from, long to) throws SQLException;

	public ArrayList<Food> getFoodByFoodCount(String foodType, int currentPage, int pageTotal) throws SQLException;
	
	public int getAllFoodRecordByFoodType(String foodType) throws SQLException;
	
	public ArrayList<Integer> getFoodTopList() throws SQLException;
}
